﻿SELECT A.`id`, A.`year_approval`,
B.`code`, B.name_spec, B.qualification,
B.id AS 'idspec'
FROM kazaku5d_test.plan_list AS A
INNER JOIN kazaku5d_test.specialization AS B
ON A.idspec = B.id
;